﻿CREATE TABLE [dbo].[blog_post] (
    [content_item_id] BIGINT NOT NULL,
    [blog_id]         BIGINT NOT NULL,
    CONSTRAINT [PK_blog_post] PRIMARY KEY CLUSTERED ([content_item_id] ASC),
    CONSTRAINT [FK_blog_post_blog] FOREIGN KEY ([blog_id]) REFERENCES [dbo].[blog] ([blog_id]),
    CONSTRAINT [FK_blog_post_content_item] FOREIGN KEY ([content_item_id]) REFERENCES [dbo].[content_item] ([content_item_id])
);

